Viewing 15 posts - 2,866 through 2,880 (of 3,738 total)
Steve Hindle-535638 (6/13/2011)
the course specifically said to add the user to the fixed database roles of db_owner AND db_securityadmin
If you add the User to the fixed database roles...
June 13, 2011 at 8:18 am
Duncan Pryde (6/13/2011)
I used UserName as a primary key in all tables, but UserID would work equally well.
Duncan
UserID would probably be the better option since it is possible to have...
June 13, 2011 at 8:15 am
aarunkumarreddy (6/12/2011)
in sql server 2008 r2 the instances are (named+ default) 50+1 or 49+1
Is this a trick question? 🙂
June 12, 2011 at 10:37 pm
Then you probably want to write in parallel to a table and then out to the csv file.
June 12, 2011 at 10:35 pm
You can use the SQL Server Import and Export Wizard or if you prefer you can do it manually by defining a Source Connection (Database) and a Destination Connection (File).
To...
June 12, 2011 at 10:15 pm
miss.delinda (6/12/2011)
What is parallelism?I want to using SCOPE_IDENTITY(). After read about parallelism, it make me afraid
The following article contains a solution to this problem:
June 12, 2011 at 10:10 pm
You need to define a connection to each table in each database.
You should append the results to the csv file.
Why do you want to execute this in parallel?
June 12, 2011 at 9:57 pm
Perhaps I missed it but what is your source object?
Please define. I assume that your Source is a SQL Server query or table?
June 12, 2011 at 9:48 pm
One option is to use the Configuration Manager as described in the following URL:
June 12, 2011 at 9:36 pm
amir.krugliak (6/12/2011)
since when File sysem task can create an excel file.
I dont think it can be done.
It is possible by script to delete an excel file but i...
June 12, 2011 at 9:27 pm
Digs (6/12/2011)
Questions:
1) How does one get a count of the number of currently on line?
2) How does one get a...
June 12, 2011 at 9:03 pm
Duplicate post. Please reply to http://www.sqlservercentral.com/Forums/Topic1123992-391-1.aspx
June 12, 2011 at 8:56 pm
raghukankanala (6/12/2011)
I have a stored procedure which generates data in a temp table..This same SP is run on 4 different databases parallel.The 4 temp tables data should be merged and...
June 12, 2011 at 8:20 pm
Which is it you don't want a cube?
I want to make some reports on a dimensional model not in a cube.
But the second phase of the project requires...
June 12, 2011 at 7:47 pm
idyana (6/12/2011)
To Mr The Dixie Flatline & Mr Welsh Corgi,Thanks for your technical info. Let me digest it. Will get back to you ASAP
Payment Type appears to be an attribute...
June 12, 2011 at 7:30 pm
Viewing 15 posts - 2,866 through 2,880 (of 3,738 total)