SQL+script - online discussion summary

t-sql script drop user account DB server

Started 1 week, 6 days ago (2009-06-26 19:30:00) by Joe K.

I would like a t-sql script that can be run on numerous SQL Server 2005 database servers to delete approximately 100 user accounts from the database server. Please help me complete this task.

Source: SQL Server Forum

Forum: SQL

Thread: Show this thread (4 posts)

Size: 215 bytes
Related Threads: Same Site | All Sites
Customize:

t-sql script drop user account DB server in microsoft.public.sqlserver.programming

Started 1 week, 6 days ago (2009-06-26 11:29:00) by Joe K.

I would like a t-sql script that can be run on numerous SQL Server 2005 database servers to delete approximately 100 user accounts from the database server. Please help me complete this task.

Source: Discussions in microsoft.public.sqlserver.programm...

Forum: microsoft.public.sqlserver.programming

Thread: Show this thread (3 posts)

Size: 566 bytes
Related Threads: Same Site | All Sites
Customize:

SQL script

Started 2 weeks, 2 days ago (2009-06-24 02:20:00) by d1zl3

Hey Im looking for an sql script that will shop the top five entrys regarding a certain column. In my case, its a auction site, and i want the script to show the top 5 sellers. the tabel is called thrillbid_users, and the table that shows how much items they sold is items_sold. A site that uses the exact same auction script as me is webidz.com. Im looking for it just like on the right middle of ...

Source: Webmaster-Talk.com Webmaster Forum - Web Design, C...

Forum: Coding Forum

Thread: Show this thread (3 posts)

Size: 420 bytes
Related Threads: Same Site | All Sites
Customize:

one sql script for mssql 2000 and mssql 2005 (or later)

Started 2 weeks, 2 days ago (2009-06-23 09:51:00) by Jono

Is it possible to write a sql script that'll run some sql for 2000 if it's installed, or some other sql for 2005 or something else if version 7.. or something's installed - e.g. do nothing? I can get the server version with @@VERSION, I think. I can't seem to make it work in an if/else bit o' code. What it's for: For 2000 I'd do --create some users: EXEC sp_addlogin ......

Source: Overclockers UK Forums

Forum: HTML, Graphics & Programming

Thread: Show this thread (3 posts)

Size: 807 bytes
Related Threads: Same Site | All Sites
Customize:

Cut an sql script output

Started 2 weeks, 2 days ago (2009-06-23 08:28:00) by aishwaryakala

Hi i want to cut the first field of this output obtained form sql script more dxlocks_test.log.1 SID SERIAL# SPID ---------- ---------- --------- 25 18356 1029 78 39370 1025 136 14361 1027 ================================ cut -f1 dxlocks_test.log.1 > compare ================================ more compare SID SERIAL# ...

Source: The UNIX Forums - the Top UNIX & Linux Q&A...

Forum: UNIX for Dummies Questions & Answers

Thread: Show this thread (3 posts)

Size: 1,326 bytes
Related Threads: Same Site | All Sites
Customize:

Missing fields after Execute SQL Script

Started 2 weeks, 3 days ago (2009-06-22 12:24:00) by Matthew Pugsley Junior Member

I seem to be losing my fields after an Execute SQL Script. I have a transformation that takes data from a csv file, does a few things, and then does an insert/update on a Postgres table. The transformation works fine without the Execute SQL Script step. But I would like to add this step in order to delete data from the last couple of months before I do the insert/update. Recent data ...

Source: Pentaho Community Forums

Forum: Pentaho Data Integration [Kettle]

Thread: Show this thread (1 post)

Size: 7,308 bytes
Related Threads: Same Site | All Sites
Customize:

Missing fields after Execute SQL Script

Started 2 weeks, 3 days ago (2009-06-22 12:24:00) by Matthew Pugsley

Source: Pentaho Community Forums

Forum: Data Integration / ETL

Thread: Show this thread (1 post)

Size: 7,308 bytes
Related Threads: Same Site | All Sites
Customize:

How can I install multiple database through SQL script

Started 2 weeks, 6 days ago (2009-06-19 08:43:00) by Marc Hoesen

Hi, does anyone know a way to create multiple databases by means of the SQL script? In InstallSheld 12 I can create a connection in the SQL Script view. There I can enter a catalog name (db name) and mark the checkbox 'create if absent'. But each script will use the same connection. I want to create multiple databases at the same server (connection). How can I create multiple ...

Source: Community - powered by vBulletin

Forum: InstallShield Windows 12

Thread: Show this thread (3 posts)

Size: 518 bytes
Related Threads: Same Site | All Sites
Customize:

Help Required on the SQL Script...

Started 3 weeks, 2 days ago (2009-06-16 13:45:00) by Jay_se

I am having the below secnario. Table 1 Col1 Col2 Col3 10 20 30 Table 2 Code Name 1 Col1 2 Col2 3 Col3 Expected Output: 1 Col1 10 2 Col2 20 3 Col3 30 How to write the SQL script (SQL server 2005) for this? Thanks in advance.

Source: CodeProject: Discussion Boards. Free source code a...

Forum: SQL / ADO / ADO.NET

Thread: Show this thread (10 posts)

Size: 500 bytes
Related Threads: Same Site | All Sites
Customize:

Run SQL script against an array of databases

Started 3 weeks, 3 days ago (2009-06-15 17:12:00) by mlowe9

Please let me start by saying I really don't know the syntax for SQL scripts when it comes to variables, loops, etc., so my example code I'm sure isn't close to what I need. Could someone share with me the syntax to run a SQL script against an array/list of databases. So instead of doing: CODE USE DB1 select count(*) from users USE DB2 select count(*) from users USE DB3 select count(*) ...

Source: Tek-Tips Forums

Forum: Microsoft SQL Server: Programming

Thread: Show this thread (13 posts)

Size: 894 bytes
Related Threads: Same Site | All Sites
Customize:

SQL script | Topic profile

Posting activity graph on sql script:

Related topics:

sql script was discussed on the following sites:

Related threads on sql script:

Latest threads on sql script:

Hot threads on sql script: