Search results for query: *

Hi all, How can i change the field to make it increment automatically. such as ID field to auto increment for each entry. Thanks

Hi all, I am trying to change the column with varchar instead char and add additional colum in to table but it says that it cannot be modify because the table is in replication while thereis no replication running on that table and i have deleted all the reaplication running so what is the...

How can i solve this error? Please help

Hi guys, How can i perform internal locking system through SQL on database rather than from frontend!!how can i perform that!!! Thanks

Hi all, Need to check what the table size after the data transfer. How can i change is and how can i increase the size of it!! thanks

Hi all, I have code written in to c++ and C# to save blob which converts whole thing in to string and save it in to database but if it is > 8K then it saves the file in to server and saves the link in to database. so if i want to save that blob in to database which takes long time and i want to...

somehow the logreader stopped and saying that it faild due to The process could not execute 'sp_replcmds' on 'servername'. The step failed what should i do to solve it!! Thanks

Hi all, I am trying to change the setup parameter from "-d"C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" To "sqlservr -d"C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" -T3111" How can i do that???

Hi all, How can i set the trace like sqlservr -d"C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" -T3111 what is the step!!! Thanks

Why would my application connection to database server is timing!! is there a reason!! i am trying to figure out but not able to figuring out so asking here. thanks

Hi there, How can i set up the performance monitor on my each database usage. Please anyone tell me how? Thanks

Hi all, My users are seeing thie error and i cannot figure it out what it is about: Error:CADODatabase Error Code: 30040e31 Code meaning: IDispatch error # 3121. What this means and what i can do to solve it??? Thanks.

Getting this error in back up: Error: The media family on devise "Drive specification" is incorrectly formed. SQL Server cannot process this media family. BACKUP LOG is terminating abnormally. BACKUP failed to complete the command BACKUP LOG [test] TO DISK = N'G:\logfile\testlog' WITH INIT ...

Hi all, I am getting this error while my log back up job runs and it is lines several error on same thing: " BlkHeader from strip 0 At 38a86400 ExpectedAt 38a86400 Size f000 PrevSize f000 " what is wrong and how would i solve it?? help please!!

Hi all plese help me restoring my computer from ghost!! I am running ghost image but it gives me error after restarting the computer it tell em that "win2K cound not start because the following file is missing or corrupt <windows 2000 root>\system32/ntoskrnl.exe please re-install a cop of the...

Hi all, I want to creat calender but dont know how. Also how can i get one? how can i make the selected date in calender to be enter into database field!! Thanks

i got partition on my computer but problem is getting error while installing win 2000 on it it gice me error saying that not ehough memory on computer. and i got 120gig hard drive but partition so also trying to delete that partition!! how can i remove it and reinstall whole win2K on computer...

Hi all, Sorry to post again!!! i am getting this in database instead of selected values from combobox. the value i am gettting is "System.Data.DataRowView". What is the solutiong for this? i tried to find out but not successful so far!! Thanks

Hi all, Currently reading for oracle 9i DBA Certification. Would anyone tell me that how many exams are there and which? also which one should i take first? Thanks for the help

Hi all, I have this question, one of my data base log file is bigger than the data file why? how can i shrink it?? i tried shrinking it with dbcc shrinkfile but did not help!! any other way to do it? Thanks