I have situation where i have to every month bring in new data from Text files which are Vertical tab separated in columns and carriage return for every row. The are many such files which are entered into many tables For this i will have to manually do the DTS every month. Can we automate […]
2004-11-10
2 reads
I think you need to delete this file and initialize a new one for SQL Server backups.
2004-11-03
Since they log OR the data are required to restore, I don't worry about this. dbcc will check this.
2004-10-19
To clarify, is this only one user who needs to be looking at all stores but only two vendors, but when focusing on vendors he/she can see them all but only two stores? Or is it two different users, one of which can see all stores but only two vendors; the other can see all […]
2004-10-13
I have a problem with a view, my view is used to rerieve data from another db.when i run this query:SELECT a,b, c FROM myViewIT will get the data successfully, third column is nullable but still i have populated it.But i run this query:SELECT a,b, c FROM myViewWHERE c LIKE 'm%'instead of eliminating those values which don't […]
2004-10-04
1 reads
How can I get list of statement permissions like create table, create view, etc; granted to all users using TSQL. I know I can get it using Enterprise manager for every user separately, but I am lookig for a script since I have to run it on all my SQL Servers.Thank you.
2004-09-06
10 reads
Interesting. I know the wizard adds/drops indexes as it schemes along, just doing that shouldnt affect replication - unless it tries to change the primary key, that would not work and would break replication if it succeeded.
2004-08-16
Agreed, simply is good and remember some basics. I think one of the options used a function on the column before testing ! Optimisers don't like this and are unlikely to utilise available indexes.Sometimes simple approaches look more verbose in terms of lines of code, but believe me, several months down the line having to […]
2004-07-10
Linda,When I do select serverproperty('licensetype'), it returns disabled. When I do select serverproperty('numlicenses') it returns NULL. What does that mean? It's definitely an active SQL server.
2004-07-09
Hey all,I'm testing a bunch of new logins, both SQL Sever and Windows authentication, that have been handed off to me. Want to be able to login with QA and then see the permissions that login has on the server.I can't remember/find how to check privileges for a login I'm using at the moment. sp_helpuser isn't it.much […]
2004-07-01
1 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers