Viewing 15 posts - 1,801 through 1,815 (of 6,105 total)
Don't use EM. Use QA. You have more scripting options. And you can still get them in SourceSafe. Also, there are 3rd party tools like DBGhost you may want to...
February 7, 2007 at 7:29 am
Your best bet here is Query Analyzer. It has an option to Qualify object name by its owner under the Table Scripting Options.
February 6, 2007 at 8:28 am
If the user specifies the owner during creation, it will be so. For instance: CREATE TABLE dbo.Sales. The only other way to do this is to create an alias (like...
February 6, 2007 at 7:34 am
I've edited my post to remove the name reference, but that's still fairly close to your real name.
February 2, 2007 at 7:32 am
Two ideas come to mind:
1) BULK INSERT into a temporary table and then use an INSERT with OUTER JOIN to load the actual table.
2) Set the BATCHSIZE = 1 and...
February 1, 2007 at 8:32 pm
This would be a question best asked of one of the SQL Server development teams at Microsoft. You can certain ask for it as a recommendation here:
February 1, 2007 at 8:25 pm
The first (and obvious question) is are you installing with an account that has administrative rights over the PC? Also, are there any errors in the application or system event...
February 1, 2007 at 8:18 pm
I don't believe there is a way to alias the database. So you basically have one SQL Server for all non-production work, right? Do you have the option of installing...
February 1, 2007 at 8:12 pm
Apparently it is a known bug with the 1.1 .NET Framework. More here:
MSDN Forums - Reply from Microsoft
February 1, 2007 at 8:08 pm
Apparently it's a known bug (with .NET Framework 1.1). More here:
MSDN Forums - SQL H2 Performance Collector - Buffer Cache Hit Ratio Problem
February 1, 2007 at 8:06 pm
The app role is at the database level. The developer needs to connect to the SQL Server with a valid login first. Has the developer done that? If the developer...
February 1, 2007 at 7:59 pm
So you went through the document that talks about using tools from the Resource Kit? If so, that's the only solution I know of. Similar types of solutions we've tried...
February 1, 2007 at 2:45 pm
True, but unless ******** is a pseudonym, keep in mind that the SSC.com forums, like many others, get indexed by the search engines. Therefore, if someone googles for ********, they...
February 1, 2007 at 8:29 am
Unless you're installing a named instance it should do that by default. Where in the install proces are you running into issues? Or is it after installation you aren't able...
January 31, 2007 at 7:33 pm
Viewing 15 posts - 1,801 through 1,815 (of 6,105 total)