Viewing 15 posts - 661 through 675 (of 1,413 total)
I would advice you to uninstall SQL Server 2005 Beta 2 and instead download and install the latest preview version, the June CTP. You will find that a lot has...
June 14, 2005 at 5:55 am
A dumb question perhaps, but are you certain that you have the x64 edition of Win 2003, and not the one for Itanium-based systems?
And what do you mean with "trying...
June 14, 2005 at 5:36 am
It is possible to move them both at the same time, but everything needs to be done in the correct order. In my checklist for moving system databases, adapted...
June 13, 2005 at 4:54 pm
Just add the IDENTITY() property to a column with a number in your table. If you do not know how IDENTITY works I suggest you look it up in Books...
June 13, 2005 at 4:50 pm
Yep, and a very good best practice. My bad for not writing correct sample code, Remi is correct in that we should always try to be as correct as we...
June 13, 2005 at 4:46 pm
You can also check in the registry (and modify): Key LoginMode in HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer. 1 is Windows Only, 0 is Mixed Mode.
June 13, 2005 at 4:41 pm
insert into #mat_sample select * from mat_sample where mat_sample_id = @temp_matsampleid
Note that the temp table #mat_sample must already be created.
June 13, 2005 at 9:51 am
My guess is that you are missing a space between @TableName and the following SELECT.
June 13, 2005 at 9:47 am
I do not have 2005 here, but I seem to recall that the Business Intelligence Development Studio is located in the Visual Studio 2005 start menu folder.
June 13, 2005 at 6:29 am
The fill factor option (and pad index) can help performance since it leaves free space on each page of an index. The rows of an index are stored in index...
June 12, 2005 at 2:38 pm
If your table does not contain something that increases for every row, then you cannot do what you are asking for.
June 12, 2005 at 2:29 pm
Uhm, no. If you want to restore a database from a backup then you need the backup file, often given the extension .bak. If you only have an .ldf file...
June 12, 2005 at 2:23 pm
Have you tried SQLCMD? It is a very good improvement on the older isql and osql command line tools, and if you are used to using Query Analyzer with T-SQL...
June 10, 2005 at 4:45 pm
Generally there is very little we can suggest to solve these issues, unless it is a known bug with a Knowledge Base article related to it. I would recommend you...
June 10, 2005 at 4:43 pm
How about just taking the easy route of renaming them and wait to see if something breaks. Like you say they are most probably from some third-party software, or even...
June 10, 2005 at 4:41 pm
Viewing 15 posts - 661 through 675 (of 1,413 total)