I am trying to backup the sql server 2008 through Symantec backup exe 12,5 but can only do that when using domain admins under login in sql database. On the server domain admin is in the admin...
I have a History Table like below
R_ID Type_ID Special_ID Group_ID
1 2 1 2
2 1 3 1
3 3 2 3
...
Can we debug a store procedure..?
If you know about any tool then plz tell me.
how can i use widcard query in crstal report 11 for the string , e.g. 01148rdfeg00001,01148rsdfrr00244 , iwant to use the wild card in the parameter field like ?01148 and all the 01148********...
I'm new to MS SQL 2000-2008. I need to migrate 40 databases from 2000 to 2005. I'd like to know the best practice in doing so? Scripts, by hand or Wizard? -Thanks
Hi Experts,
I have some 'X' sql databaservers in a network .So i need a sql script lto retrieve the list of servers and their versions
servername version
aaaaa ...
Expert,
when I checked sp_who2, I could see spid 59 is block its sef, the CPU and IO is every high like below, the lastbatch always is the same time. how can I know how long the block fro...
I have an article web page that shows all of the articles in our database 5-20 at a time. Or I have the option to view all the results on a single page(As seen in the picture). I am populatin...
I have seen several posts about bcp and BULK INSERT when it pertains to flat files etc but I want to be able to pull from a table via ODBC link and insert into a SQL staging table. I just don...
Hardware Description:
1. OS: Windows Server 2003 R2 enterprise x64 SP2.
Memory Size: 16Gb , Disk free space: 13-20gb
2. SQL Server 2005 - 9.00.4035.00 (X64)
Prob...
Hello,
I am wondering if it is possible for me to select 14 rows a table and export them to a text file which i can then use to import the selected rows into a replica database on a differe...
Hello,
I am trying to automate SQL Login transfer from SQL2000 to SQL2005.
The SQL2000 database is restored onto SQL2005 server every night.
Once the db is restored, the db users will be ...
How do I copy a folder structure via an SQL SP and keeps the same security settings on the destination folders as on the source folders ?
When i make a copy now its security settings is alway...
Dear Sir,
I have a table for which I need to create a view in SLQ 2005.
My Actual table values are:
datetime trunknameout destination cause
27/10...
Hello Experts,
The following query fills up the tempdb as is, without any indexes on the tables. I have tried various applications of indexes on the tables, but nothing seems to make it ver...
Expert,
I wonder how many licensing we need to order for sql server 2008 production server, development server and Testing server?
I know we need Enterprise Manager for SQL server produc...
Please help me?
I believe the properties file has the id's which have access..does anybody know where this properties file is located.
I tried "DELETE FROM view WHERE field=N'value'" but it gives me this:
view is not updatable because the modification affects multiple base tables.
I don't know where the view takes the r...
How to backup a daatbase on a hard drive "C:/" in SQL Server through DTS Package?
hi
i am using following row number function in my sql server 2005 :
SELECT @MaxStoreId + ROW_NUMBER() OVER (ORDER BY @MaxStoreId)
but now i want the same result in sql server 2000
b...
Hi Experts,
I set up a transactional replication between two DBs. I'm using SQL Server 2005 and set up the replication as a pull subscription.
Now I get the following error:
2009-03-25...
Experts,
Because nothing is impossible for you folks, I'd like to know: How would I go about using Soundex to search some large'ish fields using wildcards? For example:
I'd like to to s...
1. I have to compare a timestamp field against a static (hardcoded time stamp) . Can u please advice.
eg Timestamp_fied > '2009-03-22 00:00:00.000' sometin lik this but i don get the correct...
I have about 10 indexes on a read-only table. I've tried rebuilding the indexes but some of them still have around 80% fragmentation. I've got a script that drops the index and creates them ...
Dear experts,
Please can you suggest the best way to move an encrypted database / table - MS SQL 2005 from one server to another?
We have moved it once but the user with the cert doesn't...
